USE AdventureWorks2008
GO
DECLARE @CurrentTerritory hierarchyid

SELECT @CurrentTerritory = OrgNode
FROM Sales.SalesTerritoryOrg
WHERE TerritoryID = 2 ;

SELECT OrgNode.ToString() AS Text_OrgNode, *
FROM Sales.SalesTerritoryOrg
WHERE OrgNode.GetAncestor(1) = @CurrentTerritory